<?php
/*
	Copyright 2006, 2007, 2008, 2009, 2010 Bastiaan Grutters
    
    This file is part of Ages of Strife website.

    Ages of Strife website is free software: you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation, either version 3 of the License, or
    (at your option) any later version.

    Ages of Strife website is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with Ages of Strife website.  If not, see <http://www.gnu.org/licenses/>.
 */
include( "../global/initialize.php");

if( isset( $_POST[ 'officer_id' ] ) && isset( $_POST[ 'commander' ] ) ) {
	$statement = $dal->prepare( 'SELECT officer_id, rank 
		FROM officers 
		WHERE officer_id = :officer_id AND ruler_id = :ruler_id' );
	$statement->bindParam( ':officer_id', $_POST[ 'officer_id' ], PDO::PARAM_INT );
	$statement->bindParam( ':ruler_id', $_SESSION[ 'ruler_id' ], PDO::PARAM_INT );
	$officer = $dal->getObject( $statement );
	if( isset( $officer ) ) {
		$statement = $dal->prepare( 'SELECT officer_id, rank 
			FROM officers 
			WHERE officer_id = :officer_id AND ruler_id = :ruler_id' );
		$statement->bindParam( ':officer_id', $_POST[ 'commander' ], PDO::PARAM_INT );
		$statement->bindParam( ':ruler_id', $_SESSION[ 'ruler_id' ], PDO::PARAM_INT );
		$commander = $dal->getObject( $statement );
		if( isset( $commander ) && $officer->rank < $commander->rank || $_POST[ 'commander' ] == -1 ) {
			$statement = $dal->prepare( 'UPDATE officers
				SET parent_officer_id = :commander_id 
				WHERE officer_id = :officer_id' );
			$statement->bindParam( ':commander_id', $_POST[ 'commander' ], PDO::PARAM_INT );
			$statement->bindParam( ':officer_id', $_POST[ 'officer_id' ], PDO::PARAM_INT );
			$dal->execute( $statement );
		}
	}
}

header( 'Location: chain_of_command.php' );